Text_io problem [message #20209] |
Tue, 07 May 2002 02:45 |
Sam
Messages: 255 Registered: April 2000
|
Senior Member |
|
|
I'm tryin' to get data into forms with the text_io-package, but I get the message: Unhandled Exception ORA-302000: . Can anyone tell me what this means? Here's my code:
DECLARE
in_file text_io.file_type;
linebuf VARCHAR2(80);
input VARCHAR2(40);
count NUMBER;
BEGIN
in_file := text_io.Fopen('d:stagesystemreport.txt','sr');
FOR count IN 1..31 LOOP
NULL;
END LOOP;
text_io.Get_Line(in_file,linebuf);
input := substr(linebuf, 43,75);
:softwarename := :softwarename || input;
text_io.Fclose(in_file);
exception
when no_data_found
THEN NULL;
END;
|
|
|
Re: Text_io problem [message #20258 is a reply to message #20209] |
Thu, 09 May 2002 04:27 |
Phenoracle
Messages: 35 Registered: March 2001
|
Member |
|
|
I may be wrong but I thought that there was only 3 modes when you open a file.
R Read only mode
W Deletes all entries in the file and writes to it
A Appends data to the file
so what is 'sr'?
Also check to see if the file exists and is your field large enough to hold all the data.
Have fun
|
|
|